MSSQL SP내의 특정 테이블 이름 , 문자열 검색
테이블 검색
Select object_name(id) From syscomments Where text like '%tournament_ranking%'
Group by object_name(id)
Order by object_name(id)
문자열 검색
select * from sys.all_objects as o with(nolock)
inner join sys.sql_modules as a with(nolock) on o.object_id = a.object_id
where a.definition like '%ts_keyword%'
order by o.name asc
Trackback Address:이 글에는 트랙백을 보낼 수 없습니다